46. 解决方案:OR
OR 问题的解决方案
-
SELECT id FROM orders WHERE gloss_qty > 4000 OR poster_qty > 4000;
2.
SELECT *
FROM orders
WHERE standard_qty = 0 AND (gloss_qty > 1000 OR poster_qty > 1000);
-
SELECT * FROM accounts WHERE (name LIKE 'C%' OR name LIKE 'W%') AND ((primary_poc LIKE '%ana%' OR primary_poc LIKE '%Ana%') AND primary_poc NOT LIKE '%eana%');